2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 003 #BIReleases2013

Release Notes

8481.700 - Assist with Crystal Report updates

Admin Info

Purpose
 Need to update Crystal reports from 7.0 to 7.3 for sales analysis, open orders and service levels
Release No
 003
Submitted
 10/03/2013
Submitted by
 Praveen Guntuka
Source/Destination Systems
 NBP to BPD
Release Sent To
 Jack Mehltretter
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name(s)

Below are the list of Crystal Reports and their respective BW 7.0 Production and BW 7.3 Development queries:

SNo
 Folder
 Report
 Source
 BW Query
 New BW Query
1.
 Sales Analysis
 SA150 - Sales % to Goal
 BW
 ZMP_OPASA_Q034
 ZMP_OPASA_Q011
2.
 Sales Analysis
 SA160 - Shipped + Open by Sales Rep and Customer
 BW
 ZMP_OPASA_Q013
 ZMP_OPASA_Q012
3.
 Sales Analysis
 SA170 - Shipped + Open by Region and Country
 BW
 ZMP_OPASA_Q014
 ZMP_OPASA_Q013
4.
 Sales Analysis
 SA175 - Sales Analysis by Region and Country
 BW
 ZCOPA_CO3_Q001
 ZCOPA_CO3_Q003
5.
 Sales Analysis
 SA200 - Sales Analysis by Sales Org, SBU and Customer
 BW
 ZMP_OPASA_Q015
 ZMP_OPASA_Q014
6.
 Sales Analysis
 SA210 - Sales Analysis by Sales Org and Customer
 BW
 ZMP_OPASA_Q015
 ZMP_OPASA_Q014
7.
 Sales Analysis
 SA215 - Sales Analysis By Sales Org, Customer Group and Customer
 BW
 ZMP_OPASA_Q016
 ZMP_OPASA_Q015
8.
 Sales Analysis
 SA220 - Sales Analysis by Sales Org, Country and Customer
 BW
 ZMP_OPASA_Q017
 ZMP_OPASA_Q016
9.
 Sales Analysis
 SA230 - Sales Analysis by Sales Org, License and Team
 BW
 ZMP_OPASA_Q018
 ZMP_OPASA_Q017
10.
 Sales Analysis
 SA231 - MLB Sales Analysis by Material Group and Region
 BW
 ZMP_OPASA_Q019
 ZMP_OPASA_Q018
11.
 Sales Analysis
 SA240 - Sales Analysis by Sales Org, Silhouette and Collection
 BW
 ZZCOPA_C03_029
 ZCOPA_CO3_Q004
12.
 Sales Analysis
 SA270 - Sales Analysis by Sales Org,Sales Rep and Customer
 BW
 ZZCOPA_C03_034
 ZCOPA_CO3_Q005
13.
 Sales Analysis
 SA275 - Sales Analysis By Sales Org, Country, Sales Rep and Customer
 BW
 ZZCOPA_C03_033
 ZCOPA_CO3_Q006
14.
 Sales Analysis
 SA300 - Sales Analysis By Region, License and Sales Org
 BW
 ZMP_OPASA_Q036
 ZMP_OPASA_Q019
15.
 Sales Analysis
 SA350 - Sales Analysis for Hot Market
 BW
 ZCOPA_C03_043
 ZCOPA_CO3_Q007
16.
 Sales Analysis
 SA900 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season and Collection
 BW
 ZCOPA_C03_Q057
 ZCOPA_CO3_Q008
17.
 Sales Analysis
 SA905 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material
 BW
 ZCOPA_C03_Q060
 ZCOPA_CO3_Q009
18.
 Sales Analysis
 SA910 - Sales Analysis by Sales Org, SBU, Sport, License, Team and Style
 BW
 ZCOPA_C03_Q058
 ZCOPA_CO3_Q010
19.
 Sales Analysis
 SA915 - Sales Analysis by Sales Org, SBU, Sport, License, Team, Style and Material
 BW
 ZCOPA_C03_Q059
 ZCOPA_CO3_Q011
20.
 Sales Analysis
 SA920 - Sales Analysis by Sales Org, Sales Manager, Style, License, Sales Rep and Account
 BW
 ZCOPA_C03_Q061
 ZCOPA_CO3_Q012
21.
 Sales Analysis
 SAS270 - Sales Analysis by Sales Rep
 BW
 ZZCOPA_C03_034
 ZCOPA_CO3_Q013

Release Notes

For Infrastructure

None

For Requestor

Updated Crystal Reports are placed in IT > BMS > Production > BPD folder.

Test Notes

No need to validate the above reports, untill the sources in BW are moved to quality.

Reference Document(Specification)

2013-09-11 - 8481.700 - Spec - Assist with Crystal Report updates
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 001
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 002

Folder
 Report
 Source
 Comment
 BW Query
 New BW Query
Sales Analysis
 SA150 - Sales % to Goal
 BW
 Updated excel sheet from local desktop and saved in share folder
 ZMP_OPASA_Q034
 ZMP_OPASA_Q011
Sales Analysis
 SA160 - Shipped + Open by Sales Rep and Customer
 BW
 0Fiscyear pointed to Key()
 ZMP_OPASA_Q013
 ZMP_OPASA_Q012
Sales Analysis
 SA170 - Shipped + Open by Region and Country
 BW
 Chaged formula.. Need to check once report moved to BPQ
 ZMP_OPASA_Q014
 ZMP_OPASA_Q013
Sales Analysis
 SA175 - Sales Analysis by Region and Country
 BW
ZCOPA_CO3_Q001
 ZCOPA_CO3_Q003
Sales Analysis
 SA200 - Sales Analysis by Sales Org, SBU and Customer
 BW
ZMP_OPASA_Q015
 ZMP_OPASA_Q014
Sales Analysis
 SA210 - Sales Analysis by Sales Org and Customer
 BW
ZMP_OPASA_Q015
 ZMP_OPASA_Q014
Sales Analysis
 SA215 - Sales Analysis By Sales Org, Customer Group and Customer
 BW
ZMP_OPASA_Q016
 ZMP_OPASA_Q015
Sales Analysis
 SA220 - Sales Analysis by Sales Org, Country and Customer
 BW
ZMP_OPASA_Q017
 ZMP_OPASA_Q016
Sales Analysis
 SA230 - Sales Analysis by Sales Org, License and Team
 BW
 Changed file name from / to -
 ZMP_OPASA_Q018
 ZMP_OPASA_Q017
Sales Analysis
 SA231 - MLB Sales Analysis by Material Group and Region
 BW
ZMP_OPASA_Q019
 ZMP_OPASA_Q018
Sales Analysis
 SA240 - Sales Analysis by Sales Org, Silhouette and Collection
 BW
ZZCOPA_C03_029
 ZCOPA_CO3_Q004
Sales Analysis
 SA270 - Sales Analysis by Sales Org,Sales Rep and Customer
 BW
ZZCOPA_C03_034
 ZCOPA_CO3_Q005
Sales Analysis
 SA275 - Sales Analysis By Sales Org, Country, Sales Rep and Customer
 BW
ZZCOPA_C03_033
 ZCOPA_CO3_Q006
Sales Analysis
 SA300 - Sales Analysis By Region, License and Sales Org
 BW
ZMP_OPASA_Q036
 ZMP_OPASA_Q019
Sales Analysis
 SA350 - Sales Analysis for Hot Market
 BW
ZCOPA_C03_043
 ZCOPA_CO3_Q007
Sales Analysis
 SA900 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season and Collection
 BW
ZCOPA_C03_Q057
 ZCOPA_CO3_Q008
Sales Analysis
 SA905 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material
 BW
ZCOPA_C03_Q060
 ZCOPA_CO3_Q009
Sales Analysis
 SA910 - Sales Analysis by Sales Org, SBU, Sport, License, Team and Style
 BW
ZCOPA_C03_Q058
 ZCOPA_CO3_Q010
Sales Analysis
 SA915 - Sales Analysis by Sales Org, SBU, Sport, License, Team, Style and Material
 BW
ZCOPA_C03_Q059
 ZCOPA_CO3_Q011
Sales Analysis
 SA920 - Sales Analysis by Sales Org, Sales Manager, Style, License, Sales Rep and Account
 BW
ZCOPA_C03_Q061
 ZCOPA_CO3_Q012
Sales Analysis
 SAS270 - Sales Analysis by Sales Rep
 BW
ZZCOPA_C03_034
 ZCOPA_CO3_Q013